E>You may limit the search to one of the following applications:
Click Find to begin the search.
Key Word Search/SEB
Enter the search terms below:
E>You may limit the search to one of the following applications:
Detailed Index/SEB
is ar
s ar
s ar
CreditsB
is a trademark of Affinity Microsystems, Ltd. The Desktop Manager is a trademark of On Three, Inc. Thunderclock is a registered trademark of Thunderware, Inc. TimeOut is a trademark of Beagle Bros. Inc.
TOPS is a registered trademark of Sun Microsystems, Inc. Varityper is a registered trademark of Varityper, Inc. VAX is a trademark of Digital Equipment Corporation. VAXDraw and VAXTerm are registered trad
esign. Super LaserSpool, SuperMac, SuperSpool and SuperView are trademarks of SuperMac Technology. SuperGlue is a trademark of Solutions, Inc. SuperMacros, TimeOut, TimeOut Graph and UltraMacros are trade
marks of Beagle Bros. Inc. Symantec is a trademark of Symantec Corporation. Tech-Comm is a registered trademark of Brencom Computer Supplies. Tektronix is a registered trademark of Tektronix, Inc. Tempo
ed trademarks of Qume Corporation. Radius, Radius Full Page Display, Radius Performance Accelerator, Radius QuickCAD and Radius Two Page Display are trademarks of Radius, Inc. Ready,Set,Go! is a trademark of
Manhattan Graphics Corporation. Sensible Software is a registered trademark of Sensible Software, Inc. StatSoft is a registered trademark of StatSoft, Inc. Stepping Out is a trademark of Berkley System D
, Inc. A/UX, Apple, AppleLink, AppleShare, AppleTalk, HyperCard, ImageWriter, LaserWriter, Mac, Macintosh, MacTerminal, MultiFinder, ProDOS, SANE and MacWorks are registered
trademarks of Apple Computer, Inc. Adobe, Adobe Illustrator, Adobe Illustrator88 and Adobe Type Manager are trademarks of Adobe Systems Incorporated. Aldus and PageMaker are registered trademarks of Aldus
d ProModem are registered trademarks of Prometheus Products, Inc. PYRO! is a trademark of Fifth Generation Systems, Inc. QMS ColorScript is a trademark of QMS, Inc. QuarkXpress is a registered trademark o
f QMS, Inc. Quarterdeck Expanded Memory Manager is a trademark of Quarterdeck Office Systems. Quarterdeck Expanded Memory Manager is a trademark of Quarterdeck Office Systems. QUME and Sprint are register
egistered trademark of Howtek, Inc. PostScript is a registered trademark of Adobe Systems Incorporated. Printerpro is a trademark of Apricorn. PrintManager is a trademark of Digital Products, Inc. Print
Works and SoftStyle are registered trademarks of SoftStyle, Inc. ProColor is a registered trademark of Matrix Instruments, Inc. Prodigy is a registered trademark of Prodigy Services Company. Prometheus an
. Orange Micro is a registered trademark of Orange Micro, Inc. Paintworks, Paintworks Gold and Paintworks Plus are trademarks of Activision, Inc. Panasonic is a trademark of Matsushita Electric Industrial
Co., Ltd. PC/XT is a trademark of International Business Machines Corporation. Personal Laser Printer is a trademark of GCC Technologies, Inc. PICTure This is a trademark of FGM, Inc. Pixelmaster is a r
registered trademark of National Semiconductor Corporation. NetSerial is a trademark of Shiva Corporation. Novy is a trademark of Novy Systems, Inc. NuBus is a trademark of Texas Instruments, Inc. Office
writer is a registered trademark of Office Solutions, Inc. OKIDATA is a registered trademark of Oki America, Inc. Omnis is a trademark of Blyth Software Ltd. On Cue is a trademark of Icom Simulations, Inc
oft, MS and MS-DOS are registered trademarks of Microsoft Corporation. Microsoft, MS, MS-DOS and PowerPoint are registered trademarks of Microsoft Corporation. MiniCad+ is a trademark of Diehl Graphsoft, Inc.
Moniterm and Viking are registered trademarks of Moniterm Corporation. MultiMate is a trademark of Alisa Systems, Inc. MultiRam is a trademark of Checkmate Technology, Inc. National Semiconductor is a
ospot are registered trademarks of Microspot Ltd. MacPlot Professional is a registered trademark of CSC. MacPlus is a trademark of Linebacker. MacServe is a trademark of Infosphere, Inc. MacSpool is a t
rademark of Mainstay. MacWeek is a trademark of Coastal Associates, L.P. MegaTalk is a trademark of MegaGraphics, Inc. Micromodem and SmartModem are trademarks of Hayes Microcomputer Products, Inc. Micros
Itek Graphix is a trademark of A.B. Dick Company, licensed to Itek Graphix Corporation. Kurta is a registered trademark of Kurta Corporation. LASERgenix is a trademark of Devonian International Software Co.
LaserSpool is a trademark of Digital Products, Inc. Linotronic and Linotype are trademarks of Linotype AG and/or its subsidiaries. MacDraft is a trademark of Innovative Data Design, Inc. MacPlot and Micr
ontage are trademarks of Presentation Technologies. ImageStudio is a trademark of Esselte Pendaflex Corporation. Information Presentation Technologies is a trademark of Information Presentation Technologies
, Inc. Informix is a registered trademark of Informix Software, Inc. InterMail is a trademark of Microsoft Corporation. ITC Zapf Dingbats is a registered trademark of International Typeface Corporation.
Micro, Inc. Hayes is a registered trademark of Hayes Microcomputer Products, Inc. Hewlett-Packard, HP and PaintJet are registered trademarks of Hewlett-Packard Company. Houston Instrument is a trademark of
AMETEK, Inc. HyperDA, HyperEngine and Symmetry are trademarks of Symmetry Software Corporation. IBM and PS/2 are registered trademarks of International Business Machines Corporation. ImageMakerPlus and M
GEM is a registered trademark of Digital Research Inc. Graphic Edge and GraphMerge are trademarks of PinPoint Publishing. Graphicard, Microbuffer and Microbuffer II+ are registered trademarks of Practical
Peripherals, Inc. Graphics Department is a trademark of Sensible Software, Inc. Graphworks and Visualizer are trademarks of PBI Software, Inc. Grappler and Orange Micro are registered trademarks of Orange
f E-Machines, Inc. Epson is a registered trademark of Seiko Epson Corporation. Ethernet is a trademark of Xerox Corporation. FilmPrinter is a trademark of Mirus Corporation. FlashBox, InBox and Sun are
trademarks of Sun Microsystems, Inc. Font/DA Juggler and MasterJuggler are trademarks of ALSoft, Inc. FreeHand is a trademark of Aldus Corporation. Full Impact is a trademark of Ashton-Tate Corporation.
ademarks of CE Software, Inc. Digital Darkroom and SuperPaint are trademarks of Silicon Beach Software, Inc. DispayWrite, IBM and IBM PC are registered trademarks of International Business Machines Corporat
ion. Draw Plus is a trademark of Digital Research Inc. Dreams is a registered trademark of Innovative Data Design, Inc. DXF is a trademark of Autodesk, Inc. E-Machines and The Big Picture are trademarks o
k is a trademark of Data Description, Inc. DataViz is a trademark of DataViz, Inc. dBASE is a registered trademark of Ashton-Tate Corporation. DeluxePaint is a registered trademark of Electronic Arts, Inc.
DeskJet and DeskWriter are trademarks of Hewlett-Packard Company. DeskJet is a trademark of Hewlett-Packard Company. Diablo is a trademark of Xerox Corporation. Dialog Keys, QuicKeys and QuickMail are tr
is a registered trademark of CompuServe, Inc. ComputerCraft is a registered trademark of ComputerCraft, Inc. Copy II Plus is a trademark of Central Point Software, Inc. Cricket Draw and Cricket Graph are
trademarks of Cricket Software, Inc. CROSS-WORKS and SoftSpoken are trademarks of SoftSpoken, Inc. CRtronic, Helvetica and Times are registered trademarks of Linotype AG and/or its subsidiaries. Data Des
nd ColorView are registered trademarks of CalComp Inc. Canon is a registered trademark of Canon Inc. Canvas is a trademark of Deneba Software. ColorPro, DraftMaster, DraftMaster II, Hewlett-Packard, HP, H
P DraftPro and PaintJet are registered trademarks of Hewlett-Packard Company. ColorQuick and Phaser are trademarks of Tektronix, Inc. Compugraphic is a registered trademark of Agfa Corporation. CompuServe
s. is a registered trademark of Beagle Bros. Inc. Berol is a registered trademark of Berol Corporation. Bit Pad Plus and Summagraphics are registered trademarks of Summagraphics Corporation. Bitstream is
a registered trademark of Bitstream Inc. Brother is a trademark of Brother International Corporation. CADMOVER and Kandu Software Corporation are registered trademarks of Kandu Software Corporation. CalComp a
d Engineering is a registered trademark of AE Research, Inc. AT&T and UNIX are registered trademarks of AT&T. AutoCAD is a registered trademark of Autodesk, Inc. AutoMac is a trademark of Genesis Micro So
ftware. AW2 Expander, DataLink, GS Ram Plus, RamKeeper, RamWorks III and TransWarp GS are trademarks of AE Research, Inc. Bank Street Writer is a registered trademark of Broderbund Software, Inc. Beagle Bro
Corporation. Amiga and Commodore are registered trademarks of Commodore Electronics Limited. Antic and FLEXFORM are trademarks of Antic Publishing Co., Inc. Aox DoubleTime-16 is a registered trademark of
Aox Incorporated. Apple Desktop Bus, Finder, HyperTalk, QuickDraw and Switcher are trademarks of Apple Computer, Inc. Apple Writer, Finder, GS/OS and UniDisk are trademarks of Apple Computer, Inc. Applie
Changing@
Exporting@
Record@
SettingK
Sliding@
n is a registered trademark of ACIUS, Inc. A/UX, Apple, AppleLink, AppleShare, AppleTalk, HyperCard, ImageWriter, LaserWriter, Mac, Macintosh, MacTerminal, MultiFinder, ProDOS, SANE and MacWorks are registered
trademarks of Apple Computer, Inc. Adobe, Adobe Illustrator, Adobe Illustrator88 and Adobe Type Manager are trademarks of Adobe Systems Incorporated. Aldus and PageMaker are registered trademarks of Aldus
1990 Claris Corporation. All Rights Reserved.
Claris, FileMaker, HyperTour, MacDraw, MacPaint, MacProject, MacWrite, SmartForm, SmartForm Assistant and SmartForm Designer are registered trademarks of Claris
Corporation.
AppleWorks is a registered trademark of Apple Computer, Inc., licensed to Claris Corporation.
1-2-3, DIF and Lotus are registered trademarks of Lotus Development Corporation. 4th Dimensio
Every attempt has been made to recognize trademark protection. However, ommisioon from this list of any product or
trade name does not necissarilly indicate the name is not protected by trademark.
gistered trademark of Varityper, Inc. VAX is a trademark of Digital Equipment Corporation. VAXDraw and VAXTerm are registered trad
The TechInfo Library is produced by Claris Technical Support
Design/Implementation: Bill Marriott
Editors: Tom Barnum, Ben Diebold, Andreas Guralas, Bill Marriott, Megan Thomas, Larry Faulks
Documentation: BiB
ll Marriott
Brief Index/SEB
r Company. XyWRITE is a trademark of XYQUEST, Inc.
Concluded with the PLP. After the output is spooled, you can use Print Manager utility to print the spooled file.
FileMaker
11/1/90M
LELES9030559376O
Copyright
A0How to Use FileMaker II Files with FileMaker Pro
The following information was inadvertently omitted from the FileMaker Pro documentation:
FileMaker Pro can read FileMaker II files directly. When you open a FileMaker II file in FileMaker Pro, the file is per
Quick
Quickdraw
Quite
roPro International Corporation. Working Software is a trademark of Working Software, Inc. WriteNow is a trademark of T/Maker Company. XyWRITE is a trademark of XYQUEST, Inc.
emarks of Telos Corporation. VersaCAD is a registered trademark of Versacad Corporation. Videx is a registered trademark of Videx, Inc. Wingz is a trademark of Informix Software, Inc. Wizard is a regist
ered trademark of Wesper Corporation. Word Finder is a registered trademark of Microlytics, Inc. WordPerfect is a registered trademark of WordPerfect Corporation. WordStar is a registered trademark of Mic
t. Use the formula:
(Measurements - Average (Measurements))^2
2. Define another calculation field, StDev.sample, with a Number result. Use the formula:
(Sum(D)/(Count(Measurements)-1))^.5
F*The result of StDev.sample will be 16.46.
FileMaker
11/12/90M
BIMAR9031641564O
Copyright
Helvetica
Geneva
CL Futura CondensedLight
C Futura Condensed
Times
Monaco
Chicago
Courier
L Futura Light
Claris
XB Futura ExtraBold
Palatino
N Helvetica Narrow
University Roman
1Stone Serif
2Stone Sans
of a sample be used, rather than the standard deviation of a population. To find the correct deviation of a sample, you must calculate the value the "long" way:
Suppose you want to find the sample standard deD
viation given Measurements, a repeating field containing the values 90, 85, 87, 50, 92, 95, and 100
1. Define a new calculation field, D, with the same number of repetitions as Measurements, and a number resul
In FileMaker Pro 1.0v1, the "Do not print selected objects" option in the Slide Objects dialog box lets you control whether an object appears when you print or preview the report.
You can further format a non-
printing object to slide/shrink. Although it might seem nonsensical to "slide" an invisible object, the combination of sliding and non-printing options gives you an added measure of control over the way your la
yout appears. Here are some examples of how sliding options affect the appearance of your report:
1. Non-Printing, No Sliding Options
The object does not appear when printed, and objects to the right and below
the invisible object do not move up to occupy the unused space.
2. Non-Printing, Sliding Activated
The object does not appear on the layout, and any space taken up by the object is removed. Objects below and EHto the right of the non-printing object move to occupy the unused space.
FileMaker
9/20/90M
BIMAR9026359533
Copyright
A5MacPaint Picture Appears as Full-Page Image on Layout
Occasionally, you will try to import a MacPaint image and receive the message, "The object(s) are too large to paste on this layout. Make the layout larger before trying again." Or, you may import a small image
Image
Images
Imagewriter
Imagewriters
Immediately
Import
Import/export
Important
Impossible
Improve
#ctly
Indefinitely
Indicate
Indicates
Information
Inherent
Initiated
Inits
Instead
Instruct
Integrated
Intended
Intermittently
Introduction
Investigate
Invisible
Involved
1.0v1
16.46
28405
407-997-0774
622-7627
727-2329
Above
Accessing
Accessory
Activated
Active
Actual
Actually
Add-on
Added
Adding
Addition
Additional
Additionally
Affect
Areas
Around
Arrange
Arranged
Arrangement
Array
Arrays
Arrow
Asking
Associated
Attempt
Attributes
Auto-enter
Automatic
Automatically
Available
Average
Avoid
Avoids
Backdrops
Background
Backup
Backward
Based
Basic
Batch
Because
and discover that the resulting object is much larger than necessary.
The problem occurs whenever you choose "MacPaint" from the pop-up list of import translators for graphic images. "MacPaint" is the name of
the original XTND translator for paint-format images; you probably received this version of the translator when you purchased MacWrite II. This old version of the translator filter always brings in the full, 8
x 10 image, regardless of how much space is actually used by the graphic. A more recent version of the MacPaint filter is shipped with FileMaker Pro and Claris CAD 2.0. This new filter, named "MacPaint 2.0," c
rops all images before they are placed on a layout. If the MacPaint image is only 1-inch square, it occupies only one inch on the layout.
You should remove the file, "MacPaint" from the Claris Translators foldFier in your Claris folder. You can then use the MacPaint 2.0 filter with all XTND-compatible applications.
FileMaker
9/20/90M
BIMAR9026361633O
Copyright
A2Use of the Summary() Function in Calculated Fields
The FileMaker Pro Users Guide, pages A37-A39 incorrectly states that only one summary function may be used at a time in a calculation formula. This restriction was lifted after the manual was printed. You can u
se any number of Summary() functions in a calculation field.
That section also indicates that under some conditions you do not need to sort/preview a database for the summary function to return a value. This f
eature was removed because it would force a recalculation every time a record was added or modified. In FileMaker Pro 1.0v1, you must always sort a file before the summary function will return a value.
FileMaker
9/20/90M
BIMAR9026363520O
Copyright
A.Beeps when Choosing from Popup Menus or Typing
Before
Behalf
Behave
Behind
Being
Below
Benefit
Better
Between
Biggest
Black
Black&white
Blocks
Board
Boards
Borders
Bottom
Bounding
Bright
Bring
Bringing
Brings
Brown
Brown-type
Browse
Browsed
Builds
Built-in
Button
Bypassed
Issues
Item's
Items
Itself
Jumpy
Keyboard
Large
Larger
Laser
Laserwriter
Laserwriters
Lastly
Later
Layer
Layering
Layout
Layouts
Letters
Letting
Level
Lifted
Light
Limit
Limitation
Limitations
Limits
Flashing
Folder
Folders
Follow
Followed
Following
Format
Formatted
Formatting
Formula
Forward
Found
Front
Fully
Function
Functions
Further
Future
Gadgets
Generally
Generate
Given
Gives
Graphic
Graphically-oriented
Graphics
Greater
Occasionally, you will be entering text or selecting options from popup menus in FileMaker Pro, when a beep issues from the Macintosh speaker. This beep could be from several sources:
The alarm clock desk ac
cessory. Check for a flashing alarm clock over the Apple menu item. Choose the alarm clock desk accessory and turn off the alarm to turn off the flashing alarm clock.
A startup document (INIT) or control pane
l device (CDEV) like SuperClock!, which issues a beep every hour or fifteen minutes, or whenever the count-down timer function in those utilities reaches zero.
Some viruses will attempt to use Macintalk (a sp
eech synthesis program) to speak a message to you. If Macintalk is not available, the speaker will beep, instead.
The "Beep on questionable spellings" option is active. Choose "Spelling Options" from the Chec
,k Spelling menu item to disable the beeping.
FileMaker
7/31/90M
BIMAR902128700O
Copyright
Cabling
Calculate
Calculated
Calculation
Calculations
Called
Calling
Cancel
Canceling
Cannot
Cause
Caused
Causes
Causing
Cdevs
Ceases
Certain
Certified
Certify
Chance
Checkmark
Choice
Choices
Choose
Choosing
Chosen
Claris
Click
Clicking
Clipped
Evaluation
Every
Evident
Exactly
Example
Examples
Exclusive
Execute
Expansion
Expect
Expectations
Experiencing
Explanations
Export
Extend
Extent
Extra
Extract
Extracts
Familiar
Fewer
Field
Field's
Fields
Fifteen
Figure
Filed
Filemaker
Occurs
Offer
Offered
Offers
Often
Older
Omitted
A%Mixing Calculation and Summary Fields
In FileMaker Pro, you can use the Summary( ) function in a calculation field to extract values from summary fields. This works well whenever you have to use the data from a single summary field in additional ca
lculations.
However, in FileMaker Pro 1.0v1, a problem can occur when you attempt to combine several summary and calculation fields. Consider the following example:
1. Summary field S1 finds the total of valu
es in field X
2. Calculation field C1 extracts the value in S1 with the formula Summary(S1,S1)
3. Summary field S2 finds the total of values in field C1
4. Calculation field C2 extracts the value of S2 with the
formula Summary(S2,S2)
5. Summary field S3 finds the total of values in field C2...
(and so on...)
In the above example, each field builds on the value in prior fields. FileMaker automatically evaluates fie
lds in the proper order when only calculation fields are involved. However, summary fields are not fully integrated into this evaluation order scheme.
In FileMaker II, calculation fields are evaluated immediat
ely; summary fields are calculated when you print or preview a report. There is no support for "tiered" summary fields. And in FileMaker Pro 1.0v1 this algorithm is not significantly changed.
In the example ab
ove, the logic of the fields dictates that FileMaker should evaluate summary field S1, then calculation field c1, then summary field S2, then calculation field C2. What instead occurs is that all calculation fi
elds are evaluated, then all summary fields are evaluated.
Unfortunately, there is no way to define such a calculation in a way that works reliably. You must either limit your calculations to "one" level
t is, do not define any summary field that references a Summary( ) calculation field
or, force FileMaker Pro to recalculate a database several times until all fields contain correct results.
FileMaker
9/25/90M
BIMAR9026855375O
Copyright
Setting up Repeating Fields
Several
Shades
Shadowed
Shape
Shapes
Shift
Shift-click
Shift-n
Shipped
Ships
Shortcuts
Should
Showing
Shows
Significantly
Silently
Similar
Simplifies
Simplify
Situations
Sizes
Slide
Slide/shrink
Sliding
Small
Smaller
Smooth
Software
Someone
Something
Sometimes
Sophisticated
Moving
Multi-line
Multifinder
Multiple
Mutually
Named
Necessary
Needed
Needing
Network
Never
Newer-model
Newest
Newly
Non-color
Non-printing
Non-solid
Non-standard
Notice
Noticeable
Clock
Clone
Cobra
Color
Colored
Colors
Combination
Combine
Comes
Command
Commands
Communication
Complete
Complex
Component
Compressed
Compression
Computed
Computer
Computers
Condition
Conditions
Configuration
Confirm
Confirmed
Conflict
Consider
Considerations
Considered
Considers
Consistent
Constantly
nding
Could
Count-down
Create
In FileMaker II, you set up a repeating field by adding the field to the layout, then formatting it to repeat with the Repeat... command under the Gadgets menu. FileMaker Pro is much more strict about the way i
t requires you to define repeating fields. In fact, if you try to format a repeating field the old way, you may receive the message, "You must enter a value from 1 to 1, inclusively." FileMaker Pro is telling y
ou that you must do an extra step when formatting a field to repeat.
In FileMaker Pro 1.0v1, you must first define a field to repeat before it can be formatted to repeat:
1. Choose Define Fields from the Sele
ct menu to open the Field Definitions dialog.
2. Select the field you want to repeat.
3. Click the "Options" button.
Calculated fields will have an option below the formula window for specifying the maximum nu
mber of repeats for the field. In Text, Number, Date, Time, and Picture fields, this entry option will appear in the lower-left part of the dialog.
4. Click the checkbox and enter the maximum number of repeats
permitted. Click "Ok" to confirm the change.
5. Repeat the steps above for every field you want to hold multiple values.
6. Exit the field definitions dialog and switch to layout mode.
7. Click on the fields y
ou want to repeat and choose the Field Format command from the Format menu.
8. Indicate how many repetitions of the field should appear on the current layout.
Keep in mind that setting up a repeating field is
a two-step process: define, then format. And, when defining the maximum number of repeats for a field, keep in mind possible future expansion of your database; enter as high a number as reasonable so you can aI)void having to redefine the fields later.
FileMaker
9/25/90M
BIMAR9026860131O
Copyright
A4How Radio Buttons, Pop-up Menus, and Checkboxes Work
Determines
Developing
Deviation
Device
Devices
Dialog
Dictates
Differ
Difference
Different
Difficult
Dimmed/grayed
Direct
Directing
Directly
Disable
Disappear
Discard
Disconnect
Disconnected
Discover
Discovered
isplayed
Displaying
Disturbing
Document
Documentation
Documents
Doing
Dotted
Double-click
With the introduction of FileMaker Pro, you can now have a much greater degree of control over the way you enter data. In addition to the descriptions of radio buttons and checkboxes on page 3-33 of the FileMak
er Pro Users Guide, here are some explanations of the way checkmark and radio button field data is stored:
When you turn a checkbox from OFF to ON, the value corresponding to that radio button or checkbox is
ADDED to the end of that field.
When you turn a checkbox from ON to OFF the value corresponding to that radio button or checkbox is REMOVED from the field.
When you turn a radio button on, all other option
s are turned off, and the data in the field is replaced with the chosen option.
In text fields, Returns separate multiple selections in button arrays. In number fields, there is no separation.
Example: Suppo
se the field "Color" has the value list "
Red
Green
Orange"
1. Click on Red --> Color contains "Red"
2. Click on Green --> Color contains "Red
Green"
3. Click off Red --> Color contains "Green"
lick on Green --> Color contains "Green
5. Click on Orange --> Color contains "Green
Orange"
Thus, the order in which you selected/deselected an option determines how the data is stored in the field.
Clicking on a checkbox only adds or subtracts information; it never replaces information. Suppose you have a field, Color, that for the 100 records already stored in your database currently has the value "B
rown." Marketing decides to call all brown-type colors "Sandlewood." You change the value list for the field from Blue, Green, Brown to Blue, Green, Sandlewood. When you view the field in browse, the Sandlewood
box is not checked. You check the box. What ends up being stored is, "Brown
Sandlewood"
Clicking on a radio button always replaces the entire contents of a field with the chosen value.
You can hold down
the shift key while clicking a radio button array to force it (temporarily) to behave as if it were a checkbox array (letting you deselect an option).
FileMaker
9/25/90M
BIMAR9026860356O
Copyright
Sorting by Summary Fields
Sub-summary
Subtracts
Successfully
Summary
Supply
Support
Supported
Suppose
Switch
Switching
Sydney
Symptoms
Synthesis
System
Taken
Taking
Technical
Technical/detailed
Technique
Techniques
Telling
Templates
Temporarily
Testing
Affected
Affects
After
Again
Alarm
Alert
Algorithm
Allen
Allocation
Allow
Allows
Alphabetical
Alphabetically
Already
Alternately
Alternatives
Although
Amount
And/or
Animation
Another
Appear
Appearance
Appeared
Appears
FileMaker Pro lets you include summary fields in the sort order so that items in sub-summary reports can be ranked by summary field values, and not merely alphabetically (see Figure 1)
In effect, FileMaker Pro
temporarily treats a sub-summary section as if it were a single record, and rearranges the report so the sub-summary sections print in the arrangement based on the summary field added to the sort order.
Page
4-24 of the FileMaker Pro Users Guide describes how to sort by summary fields, but does not mention some important considerations and limitations.
1. Only one summary field may be included in the sort order.
2. Only one sub-summary section is affected by the summary sort.
Whenever you include more than one sub-summary part on your layout, you can generate a
tiered
report that mirrors the fields listed in the sor
t order. For example, if you sort first by region, then by state, and have a sub-summary by region and a sub-summary by state on your layout, the effect would be two groupings of records, as illustrated in Figu
re 2.
You may want to organize such a report by the total amount of sales in each region. The report would list the regions with the biggest sales first, then within the regions, the states with the highest to
tal first. However, when you add the summary field to the sort order, it will only arrange items within the regions. The order of regions will still be alphabetical.
3. Because the sort by summary field featur
e works only on the deepest level of the sort order, it can be difficult to see the effect of a sort by summary field when you do not have a corresponding sub-summary part for each item in the sort order.
FileMaker
9/25/90
0drw2
0drw2
0drw2
0drw2
38`38
30`30
30`30
30`30
30`30
0drw2
0drw2
q ,X0
@"
0drw2
0drw2
1drw2
C Futura Condensed
Layout
1drw2
Normal
Sort
1drw2
Sort with
Summary Field
`drw2
`drw2
`drw2
1drw2
CL Futura CondensedLight
Produces report with
subtotals only
1drw2
Report is sorted
alphabetically by State
1drw2
Subtotal sections
are rearranged according
to the result of Total Amount
1drw2
t Order
1drw2
Printed Report
0drw2
))!bA)
))'BA)
0drw2
1drw2
Helvetica
Figure 1
0drw2
0drw2
1drw2
Layout
Normal
Sort
1drw2
Sort with
Summary Field
`drw2
`drw2
`drw2
1drw2
When sorted by region,
then by state, produces
a bi-level report.
1drw2
Two-tiered report showing
sales groups first by region,
then by state.
Regions appear
alphabetically.
Within regions, states are
listed alphabetically.
1drw2
Two-tiered report showing
sales groups first by region,
then by state.
Summary sort added.
Within regions, states are
listed in ascending order,
based on the summary
field value. The order of
regions is unchanged.
1drw2
Sort Order
1drw2
Printed Report
0drw2
%/BRRB
2RRN
R !%)
%/BRRB
2RRN
0drw2
0drw2
0drw2
0drw2
PF@b$@
0drw2
0drw2
0drw2
PF@b$@
0drw2
1drw2
Figure 2
BIMAR9026860387O
Copyright
A#Exporting Summary Field Information
Some promotional literature for FileMaker Pro indicates you can export Summary field data to a text file. However, when you choose "Export..." from the file menu, summary fields are dimmed/grayed out. You canno
Lines
Listed
Lists
Literature
Loads
Locate
Located
Location
Lockup
Logic
Long-standing
Looked
Lookup
Lower-left
Luminosity
Macdraw
Machine
Machines
Measure
Mention
Menus
Merely
Message
Methods
Might
Minutes
Mirrors
Mixed
Modified
Monitor
t include them in the export order.
In order to export a Summary field's value, you must add a corresponding calculation field to the database. This calculation filed will use the Summary() function to extract
the value in the summary field. You can then export the calculation field.
For example, if you have the summary field Total Sales and would like to export its value, you would create a field CTotal Sales (cal
culation) = Summary(Total Sales, Total Sales). If you would like the value of total sales when sub-summarized by sales rep, you would create a field CTotal Sales by Rep (calculation) = Summary (Total Sales, Sal
es Rep). After creating the appropriate field, you should sort the database and then export the calculation field.
The resulting text file will include one line of information for every record in the found set
. Thus, if you have 20 records that generate 3 lines of sub-summary data, you will obtain a text file 20 lines in length, each line holding one of the three possible values of the summary field.
FileMaker
9/25/90M
BIMAR9026860424O
Copyright
A(Resizing Lines and Other Grouped Objects
Greatly
Green
Group
Grouped
Grouping
Groupings
Groups
Guest
Guests
Guest
Guide
Hairline
Handoff
Happen
Harder
Having
Height
Here's
Highest
Highlight
Holding
However
Illustrated
Image
In FileMaker Pro, you have the option of grouping several objects together into one. This greatly simplifies moving complex shapes around the layout. It also makes it easier to group text and colored backdrops.
But the group feature has some limitations. In FileMaker Pro 1.0v1, when you resize a grouped object, the component objects do not move the way they would in a graphics program like MacDraw II. The actual resu
lts can be unexpected.
In FileMaker II 1.0v1, grouped objects are resized by taking the difference in height and width between the original size and the new size, and applying that difference to each object in
the group.
This has limitations when applied to graphically-oriented groups, but works well when fields are contained within the group.
FileMaker
9/25/90M
BIMAR9026860555O
Copyright
A5Defaults and FileMaker Pro's Approach to Setting them
Setting
Shortcut
Created
Creating
Criteria
Crops
Ctotal
Current
Currently
Customer
Customers
Damage
Decide
Decides
Deepest
Default
Defaults
Defect
Define
Defined
Defines
Defining
Definitions
Degree
Delete
Deleted
Deleting
Describes
Descriptions
Deselect
Deselected
Deselects
Design
Designed
Designing
Desired
Desktop
Deskwriter
BRChanging a newly created item's attributes (such as color) also sets the defaults.C
FileMaker
9/25/90M
BIMAR9026860627O
Copyright
AHDesign Tips for Checkboxes, Pop-up Menus, Pop-up Lists and Radio Buttons
Exporting
Field
Fields
Filemaker
Files
First
Function
Grouped
Guests
Image
Information
Keyboard
Layout
Layouts
Lines
Lists
Macpaint
Menus
Mixing
Networks
Non-printing
Objects
Options
Other
Palette
Picture
Pop-up
Popup
Print
Pro's
Provided
Radio
Whenever
Where
Whether
Which
While
White
Width
Wilmington
Window
Within
Without
Words
Related
Release
Reliably
Remain
Remedies
Remove
Removed
Removing
Renumber
Repair
Repeat
Repeating
Repeats
Repetitions
Replaced
Replaces
Report
FileMaker Pro lets you design database applications that look and feel more like the Macintosh than ever. Here are some tips when using FileMaker Pro's new data entry options in a way that is consistent with th
eir design and with your users' expectations.
Radio Buttons
Radio buttons offer two or more alternatives for a given option. Only option of the list offered
never more and never fewer
can be selected. For
example, when you print to a LaserWriter, you always have an choice of where the paper comes from: manual feed or paper tray. Like other proper radio button sets, this option always has a default setting and al
ways requires a value. The settings options are always mutually exclusive. In FileMaker Pro, radio buttons are designed to meet the requirements above. Choosing one option automatically deselects the last choic
e selected. Make sure the value list for a radio button always has two or more options, and that you supply "auto-enter data" that defines the intended default value of the radio button array.
Checkboxes
Check
boxes are the appropriate way to format a field that can have one, none, or several options selected. For example, the options in the Page Setup dialog box. (You can offer as many choices as you like. However,
when you have several options, it is a good idea to arrange them into related groups.)
Pop-up Menus
Pop-up menus behave in a way similar to radio buttons, but are better than radio buttons when the list of po
ssible options is quite long. For example, in the newest release of the LaserWriter driver, a pop-up menu appears as a choice for one of several non-standard paper sizes that may be added to the dialog.
Pop-up
Lists
Pop-up lists are the original option for formatting value lists in FileMaker. They differ from the other options in a few key areas. One, they are the only option which lets you choose your selection fro
m they keyboard. Pop-up lists let you use the arrow keys to highlight the option you want. You can also just type the first few letters of the option to highlight it. Second, it is the only option which lets yo
u enter a value that is not included in the value list. In FileMaker Pro, the default option for all fields with value lists is "pop-up list."
FileMaker
9/26/90M
BIMAR9026961795O
Copyright
A6In Layout, Text from Converted Files Appears
Clipped
Occasionally, when converting files from FileMaker II to FileMaker Pro, layout text appears clipped.
This problem is actually the result of a FileMaker II problem. In FileMaker II, layout text was never clipp
FileMaker
9/27/90M
BIMAR9027038657O
Copyright
A:How to Get More Colors than Provided in the Pop-up Palette
The FileMaker Pro color palette contains 81 different colors. These colors are based on the standard system colors. Although the palette was designed to provide a wide range of colors, and in particular many p
ed (constrained) to the size of its bounding rectangle. It just started at the left and continued to the right indefinitely. FileMaker II could permit this because it was impossible to define a multi-line layoC
ut text object.
Although the text appeared normally when you browsed the file or printed, you might notice some display problems at other times. If you selected the text using the text tool, you would sometim
es notice that the highlight would not extend through all of the text. FileMaker Pro does constrain the text to the size of the bounding rectangle (to allow for multi-line text blocks), so the problem is much E
more evident.
To correct the problem, select the text tool in Layout, click in the problem text and hit enter. The bounding rectangle will be recalculated correctly.
FileMaker
9/27/90M
BIMAR9027039102O
Copyright
A$How to control how a layout is drawn
In FileMaker II, all objects are placed on the layout in a pre-defined order: Given two objects, the one above and to the left of the second object would always appear behind the second object.
Although this m
astels, you may want some additional shades. Although you cannot edit which colors are provided by FileMaker, you can combine the colors with the several gray patterns available, to produce different tints and/C
or visual effects.
Sort/preview
Sources
Space
Speak
Speaker
Specifying
Speech
Spelling
Spellings
Spool
Spooled
Square
Standard
Start
Started
Startup
State
Statement
States
Stdev
Steps
Still
Store
Stored
Stores
Strict
Structure
Structured
Styles
Sub-summarized
Paging
Paint-format
Palette
Panel
Paper
Particular
Particularly
Parts
Pastels
Pattern
Patterns
Perform
Performed
Performing
Permanently
Permit
Permitted
Personal
Picture
Pieces
Placed
Pop-up
Popup
Possible
Pre-defined
Prevent
Prevents
Preview
Print
Printed
Printer
Printing
Printout
Prior
Under
Undone
Unexpected
Unexpectedly
Unfortunately
Unnoticed
Unrelated
Unstable
Until
Unusable
Unused
ade it very difficult to construct sophisticated layouts (you could not control layering), it had the benefit of making screen refreshes appear very smooth. When switching layouts or paging between records, the
screen was drawn in an orderly, top-down fashion.
In FileMaker Pro, objects can be placed on the layout in arbitrary order. If you do not change the default object order, objects will be drawn in the order
they are created. This can lead to a very jumpy appearance because some objects at the bottom of the screen may be drawn first followed by some at the top and so on. This can be particularly disturbing with m
enu layouts that contain many buttons or graphic images.
FileMaker Pro first draws objects in the background, then objects in the foreground. If you want to improve the way a layout is drawn, use the Send to B
ack, Send Backward, Bring to Front, and Bring Forward commands under the Arrange menu. This lets you control exactly how a screen is drawn. You could even use this characteristic to create certain animation effG<ects, such as is used in the FileMaker Pro templates series.
FileMaker
9/27/90M
BIMAR9027040123O
Copyright
A.Viewing Color Layouts on Black & White Screens
Sales
Salvage
Sample
Sandlewood
Scheme
Scratch
Screen
Screens
Script
Scripts
Scrolling
Search
Second
Section
Sections
Seeing
Seems
cted/deselected
Selecting
Selection
Selections
Separate
Separation
Series
Setting
Settings
Setup
Macintalk
Macintosh
Macintoshes
Macpaint
Macwrite
Mailing
Major
Makes
Making
Management
Manager
Manifests
Manual
Mapping
Marathon
Marked
Marketing
Matter
Maximum
Meaning
Measure
Memory
Memory-related
Mention
Menus
Merely
Message
Method
When a color layout is viewed on a black machine, FileMaker Pro is forced to resolve each color to either black or white. It does this by performing a "luminosity test." This has the effect of making dark color
s appear as black, and light colors to appear as white.
This seems to be the best way for FileMaker Pro to perform the conversion, but there are also some limitations inherent in displaying color screens on a
black & white monitor:
This mapping will not work on a color machine with non-solid patterns.
Mixed runs of color on a non-color QuickDraw machine will always be black
You may use one color for text and
another for a background. Although the colors contrast well on the color screen, they could both be considered "bright" colors, and map to white on white. Or, they could both be considered "dark" colors and map
to black on black.
Drawing to an ImageWriter with a color ribbon in the standard eight colors is not supported.
Here are two good methods for designing a database that will be used by both color and black &
white machines:
If you are designing the layouts on a color machine, use the Monitors option in the control panel to toggle between black and white and full color. This will simulate what the black&white us
er will see.
You may want to set up two different sets of layouts for black & white and color machines, especially if the b&w screens are also smaller than the color ones.
""""""
FileMaker
9/27/90M
BIMAR9027041900O
Copyright
Quite
Radio
Random
Re-builds
Reaches
Rearranges
Reason
Reasonable
Reboot
Rebuild
Recalculate
Recalculated
Recalculation
Receive
Received
Recent
Recently
Reconnecting
Record
Records
Recover
Recovered
Recovering
Recovery
Rectangle
Redefine
Redefining
Reestablished
References
Refreshes
Regard
Regardless
Region
Regions
Regular
Enough
Ensures
Enter
Entering
Entire
Entry
Equipped
Error
Errors
Especially
Evaluate
Evaluated
Evaluates
Copyright
The following information was inadvertently omitted from the FileMaker Pro documentation:
FileMaker Pro can read FileMaker II files directly. When you open a FileMaker II file in FileMaker Pro, the file is per
Occasionally, it will seem that the keyboard shortcuts
such as for switching between Browse and Layout, defining text styles, formatting field options
will fail intermittently with FileMaker Pro. This is ju
st one of the symptoms of a very low memory condition. In particular, some Startup documents (INITs) and control panel devices (cDEVs) can occupy quite a bit of memory. On a standard, 1 Mb Macintosh, there may
not be enough room for FileMaker and several INITs to run properly.
You may not have approached these limits when using FileMaker II, because FileMaker Pro offers many more features than FileMaker II, and thus
Di requires more memory to run correctly.
Removing INITs generally remedies these memory-related problems.
FileMaker
9/27/90M
BIMAR9027045804O
Copyright
A?Saving Print Options such as "Current Record Only" with Scripts
Record
Renumber
Repeating
Resizing
Rodime
Sample
Saving
Screens
Scripts
Setting
Tiered
Tightly
Timer
Times
Tints
Together
Toggle
Top-down
Total
Translator
Translators
Treats
Trouble
Trying
Turned
Two-step
Types
Typically
Uncovered
Under
In FileMaker II, even though you could include a print operation in a script, you still had to choose the appropriate options in the print dialog box, at the time the script was performed. Options such as "Prin
t Current Record" would not be stored with the script.
In FileMaker Pro, the print dialog box can be bypassed. Additionally, the most recent settings of the print options are also stored with the script. Thus,
you can store the option to "print current record." A button could be placed on a layout that initiated this script and produced a single-record report with one click.
Here's how to store the print options:
Set up the desired options and perform a print operation.
Create the script which should restore those options and print the report. Indicate you should restore the Page Setup options when printing.
FileMaker
9/27/90M
BIMAR9027048823O
Copyright
Notifications
Notified
Number
Numbers
Object
Objects
Obtain
Occasionally
Occasions
Occupies
Occupy
Occur
Occurs
Constrain
Constrained
Construct
Consuming
Contact
Contain
Contained
Containing
Contains
Contents
Continued
Contrast
Control
Conversion
Conversions
Convert
Converted
Converting
Copied
Copies
Corporation
Correct
Corrected
Correcting
Correction
Correctly
Corresponding
Could
Count
Count-down
Crash
Crashed
Create
A7Networks: New Ability to Disconnect Unresponsive Guests
When FileMaker Pro is used on a network, all guests must be notified of changes in the database, such as recently added records. These notifications happen constantly in the background as you add, modify, and
delete information.
In fact, FileMaker Pro allows no further processing until all guests are updated with the necessary information.
Sometimes, however, a guest may not be able to receive this update informat
ion from the host. The guest
s machine may be doing something time consuming, or communication between the guest and host may have been lost unexpectedly.
Because this could lead to situations where all users
of the database were waiting on the behalf on a single user, FileMaker Pro now gives you the option to disconnect someone who is not responding to the host. When FileMaker Pro ceases to receive regular response
s from a guest, the following alert will appear on the host machine:
Waiting for response from Sydney West. All other users must wait until the problem is resolved or Sydney West is disconnected.
If you see t
his message on your machine, investigate why that guest
s computer is not responding to the host. If the situation can be corrected (by reconnecting the network cabling, canceling the time consuming operation,
or bringing FileMaker Pro to the foreground under MultiFinder), then the dialog should disappear once communication is reestablished. Otherwise, you can simply click
disconnect
to instruct FileMaker Pro to reH
move that guest.
FileMaker
9/27/90M
BIMAR9027054319O
Copyright
A3Errors in the Description of the Summary() Function
Filemaker
Files
Filter
Finder
Finds
Firmware
First
On page A-37, the FileMaker Pro User
s Guide incorrectly states that there are some occasions when you do not have to sort a database for the summary function to return a value. Because this feature would force
a recalculation of the entire database each time a record was added or changed, you must always sort for the summary function to work. Additionally, the manual indicates you can use only one Summary function a
t a time. After the manual was printed, but prior to the release of the software, that restriction was lifted. You can now use several Summary functions in a formula.
FileMaker
9/27/90M
BIMAR9027054744O
Copyright
Changing the Field on a Layout
Appears
Apple
Application
Applications
Applied
Applying
Approached
Appropriate
Arbitrary
Filemaker
Suppose you just set up a layout and decide that you want to change one of the fields you've included. Instead of "Full Name" you want "Last Name" to appear. In FileMaker II you had to delete the original field
and add the field you wanted instead. In FileMaker Pro 1.0v1, a feature was added that lets you change the field to another field.
To change a field on a layout to a different field, hold down the option and
C\command keys as you double-click the field. Choose the new field from the list that appears.
FileMaker
9/27/90M
BIMAR9027056596O
Copyright
A7Defining a Button to go to the "First" or "Last" Record
Full-page
Function
Grouped
Guests
Hairline-width
Import
Information
Keyboard
Layout
Layouts
Lines
Lists
Macpaint
Menus
Missing
Mixing
Networks
Non-printing
Objects
Options
Other
Palette
Picture
Pop-up
Popup
Print
Printing
Pro's
Provided
Radio
You've
Filemaker
Isn't
Issues
Although you can set up a button to go to the "next" or "prior" record, there is no direct way to indicate you want a button to go to the first record or last record. There is an easy workaround, however. For t
he button you want to go to the first record, indicate it should jump to record #1. For the button to go to the last record, indicate you should jump to record #99999.
FileMaker
9/27/90M
BIMAR9027058306O
Copyright
EPSF Images
Duplicated
Duplication
During
Earlier
Early
Easier
Effect
Effective
Effects
Eight
Either
Emmons
Empty
Emulate
Encounter
Encounters
Enhanced
Enough@
Evaluation@
Familiar\
FilemakerT
Flashing@
Greatly@
Hypercard@
Image
Into_
Issues
Layouts_
Macintalk@
Measurements@
Method
MoreF
Nonsense@
Operation@
Paging
Paste@
Quite
Related@
Report
Several@
Simply@
Sort@
Sub-summary@
UnderO
Unused
Work]
Bimar9027458710
Bimar9030558604
Bimar9030644518
Bimar9030649106
Bimar9031641564
Camon9028463480
Camon9030854180
Kejun9030537350
Leles9030559376
Leles9030561932
Leles9030562266
Metho9031135804
When an EPSF graphic is duplicated, or Copied and Pasted on the layout (or between records in Browse) the EPSF code is lost. The only part that is duplicated is the PICT associated with the graphic. The EPSF
Filter that FileMaker Pro uses stores two types of information; The PICT graphic which is displayed on the screen, and the EPSF code which is sent to the printer to produce the high quality output. These two
pieces of information do not get copied when a duplication is performed. Only the PICT is duplicated.
The result of this is a high quality button on screen and a low quality button on a printout.
FileMaker
10/1/90M
BIMAR9027458710O
Copyright
Inadvertently
Incapable
Include
Included
Inclusively
Incorporated
Incorrectly
Increasing
Indefinitely
Index
Indicate
Indicates
Information
Inherent
Initiated
Inits
Innovations
Input
Inside
Installed
Instance
Instead
Instruct
Intact
Integrated
Intended
Intermittently
Involved
Involving
A0Defining Checkboxes Which Act Like Radio Buttons
You cannot define a field as a checkbox and then use it for manual entry.
If you have two checkboxes, and want only one to be selected, you can define the second checkbox as a computed field, with the formul
a "if(field A,0,1). This results in field B showing up checked by default, but if you click in Field A, then B becomes deselected. There is no way to click in Field B.
If you have more than two checkboxes,
the most you can do is use an if statement to check to see if more than one box is checked and, if so, create a warning message. The formula might look like this: if(Field B or Field C, 1,0), if(Field B and FD
ield C, 1,0)).
FileMaker
10/11/90M
CAMON9028463480O
Copyright
A#Missing fields in the Import dialog
Bedie9030646920
Bimar902128700
Bimar9026359533
Bimar9026361633
Bimar9026363520
Bimar9026855375
Bimar9026860131
Bimar9026860356
Bimar9026860387
Bimar9026860424
Bimar9026860555
Bimar9026860627
Bimar9026961795
Bimar9027038657
Bimar9027039102
Bimar9027040123
Bimar9027041900
Bimar9027045804
Bimar9027048823
Bimar9027054319
Bimar9027054744
Bimar9027056596
Bimar9027058306
There is a problem involving scripts defined in older versions of FileMaker II when the "Restore Import order..." option was used.
After a file is converted to Pro and one of these scripts is run, only the fieB
lds that appeared in the "Input order" list in the old application will show up in Pro's input dialog.
If the script is modified or deleted IMMEDIATELY after the file is converted into FileMaker Pro format, th
e field list should remain intact.
If one of these scripts is run prior to redefining or deleting the scripts that use this option, however, the file will need to be recovered
this will reset the import ordeDOr. Immediately redefine or delete the scripts in question before running them!
FileMaker
11/1/90M
KEJUN9030537350O
Copyright
Printing Hairline-Width Lines
Image
Images
Import
Information
Keyboard
Laser
Layout
Layouts
Lines
Lists
Macpaint
Menus
Missing
Mixing
Networks
Non-printing
Objects
Options
Other
Palette
Personal
Picture
Pop-up
Popup
Print
Printer
Printing
Pro's
Provided
Radio
When you run FileMaker Pro 1.0v1 on Macintosh IIci and newer-model machines, lines set to hairline width will print as 1-point lines. This occurs no matter what version of the LaserWriter driver or system softwB
are you are using.
One method you can use to work around this limitation is to construct the line in a drawing program, then copy the image into your FileMaker Pro layout.
Another method is to use a pattern f
or the line -- the most effective seems to be the pattern on the second row from the top, third from the right, which is a white dotted pattern, with the dots arranged in a square. The lines look odd on screenD$, but print well on the LaserWriter.
FileMaker
11/1/90M
BIMAR9030558604O
Copyright
GCC Personal Laser Printer
FileMaker Pro 1.0v1 is incapable of printing directly to the GCC Personal Laser Printer (PLP). As you attempt to print, FileMaker Pro will image each page, but no output will appear on the printer.
UnfortunateB
ly, FileMaker Pro is certified to work only on Apple LaserWriters and ImageWriters.
If you own a PLP printer, you can work around this limitation by directing your output to the "Print Manager" spool utility i
manently converted to FileMaker Pro format. Once you convert the file, it is impossible to revert the file for use with FileMaker II.
All layouts, scripts, and data in your FileMaker II file are converted. OncC
e in Pro, your file should operate exactly as it did in FileMaker II. You can add new features like buttons and enhanced scripts as they are needed, whenever you like.
But converting your old files is not auto
Pro, the file is per
Force
Forced
Foreground
Forever
Format
Formatted
Formatting
Formula
Forward
Found
Front
Fully
Function
Functions
Further
Future
Gadgets
Generally
Generate
Given
Gives
Graphic
Graphically-oriented
Graphics
Greater
Method
Methods
Might
Minutes
Mirrors
Missing
Mixed
Models
Modified
Modify
Monitor
Monitors
Double-clicking
Drawing
Drawn
Draws
Drive
Driver
Drives
Familiar
Fashion
Feature
Features
Fewer
Field
Field's
Fields
Fifteen
Figure
Filed
Filemaker
Hypercard
Illustrated
Image
Because
Becomes
Beeping
Simply
Simulate
Single
Single-record
Situation
Situations
Sizes
Slide
Slide/shrink
Sliding
Small
Smaller
Smooth
Software
Solve
Solved
Someone
Something
Sometimes
Sophisticated
Sorry
75002
99999
A37-a39
About
Above
Accelerator
Accessing
Accessory
According
Activated
Active
Actual
Actually
Add-on
Add-ons
Added
Adding
Addition
Additional
Additionally
Affect
FileMaker
11/1/90M
LELES9030561932O
Copyright
eatures like buttons and enhanced scripts as they are needed, whenever you like.
But converting your old files is not auto
have selected.
Method 3: Add-On Utility
Because this situation occurs with many programs, not just FileMaker, a utility was created to simplify the conversion process. HandOff II is a startup document that letW
s you tell your Macintosh, "I want FileMaker Pro to open FileMaker II files." After you drop this into your system folder, you can open FileMaker Pro by double-clicking FileMaker II files.
Contact:
Software InX;novations
P.O. Box 1075
Allen, TX 75002
(214) 727-2329
to 16 files at once with this technique.
1. Move the FileMaker II files you want to convert into the folder where FileMaker Pro is installed.
2. Select up to 16 of the files you want converted and the FileMakeU
r Pro icon. (You can use the shift-click technique, or you can drag a selection rectangle around the files.)
3. Choose Open from the File menu.
FileMaker Pro will open, and try to convert each of the files you
do that, the list changes to display, "Acta, Claris CAD, FileMaker II, FileMaker Pro, MacDraw II, MacWrite II, QuarkXPress Program." Now, double-click the folder marked "FileMaker II." Inside that folder, yourS
two files "Copy of Order Entry" and "Copy of Mailing List Management" are listed. Click one of them to convert it.
Do this for each of your FileMaker II files.
Method 2: Batch Conversions
You can convert up
lick on the folders listed until the files you want are displayed.
Example:
Suppose your files are located in the same folder as FileMaker II. You keep FileMaker II in a folder called "FileMaker Program" insidQ
e the "Applications" folder on your hard disk. After step 2b, you see "Applications, Emmons Project, HyperCard, System Folder, and Utilities" listed. You should double-click the "Applications" folder. After you
d rectangle at the top of the scrolling list of files and hold it down as if it were a menu. This will display all the folders from your hard disk to the folder where the FileMaker Pro application is located.
b. Drag down and select your hard disk. After you release, the list of file changes to show you all the folders and FileMaker II files that are located at the "top" level of your hard disk.
c. Double-C
e-click files from the desktop, you may not be familiar with this dialog. Alternately, you may be used to always seeing the files you want listed in this window and opening them without further steps. You will M
use this dialog to locate and convert your FileMaker II files.
2. Open the copy of your FileMaker II file.
If the file isn't already listed in the scrolling list, follow these steps:
a. Click the shadowe
ed version.)
Here are the ways you can use to open your files:
Method 1: Open the File from within FileMaker Pro
1. Open FileMaker Pro by double-clicking its icon.
Whenever FileMaker Pro is opened directly, K
you get a dialog box asking you what file to open. This is the standard, Macintosh way of accessing your files from "inside" an application
it shows you files in a single folder at a time. If you always doubl
our file could be lost forever. You should always make copies of your work before performing major operations like a conversion. Also, once a file is converted to FileMaker Pro format, you cannot use it with FiI
leMaker II; the procedure cannot be undone. (Note: A quick, and safe way to make a backup is to use the "Save a Copy
" command in FileMaker II to save a compressed version of the file, then convert the compress
busy or missing)." The Macintosh is telling you that it looked for FileMaker II, and could not find it.
You probably want to use FileMaker Pro with all your old data files. There are several ways to do this; bG
efore you make any conversions however, note the following:
To protect your valuable information, make a backup copy of the FileMaker II file. Should there be any error in the conversion process, all data in y
matic. The Macintosh considers FileMaker II and FileMaker Pro as separate, unrelated applications. Thus, when you try to open a FileMaker II file from the Desktop, you may not get the result you expect. If FileE
Maker II is still on your hard disk, you will open FileMaker II when you open the file. If you have removed FileMaker II, you will get the message, "The file ... could not be opened/printed (the application is
HP DeskWriter Compatibility
FileMaker
11/1/90M
LELES9030561932O
Copyright
HP DeskWriter Compatibility
Workaround
Works
Would
Writing
Xtnd-compatible
Change
Changed
Changes
Changing
Characteristic
Charge
Check
Checkbox
Checkboxes
Checked
Checkmark
Choice
Choices
Choose
Choosing
Chosen
Circled
Claris
Click
Clicking
Clipped
Operation
Operations
Option
Options
Orange
Order
Orderly
Organize
Organized
Original
Other
Otherwise
Output
Ovals
Owners
Pagemaker
Pages
Paging
Q. Does FileMaker Pro work with the HP DeskWriter?
A. We do not certify on the HP DeskWriter, and do not have problems when using Apple LaserWriters or ImageWriters. The DeskWriter works well to the extent it B
is able to emulate an Apple printer. FileMaker Pro works best with the DeskWriter when operated under MultiFinder, which ensures better management of available memory. Also, other add-ons and startup documents
CYcan use up valuable memory and make it harder to print successfully with the DeskWriter.
FileMaker
11/1/90M
LELES9030562266O
Copyright
Dove Accelerator Boards
Some owners of FileMaker Pro 1.0v1 may encounter problems using the program on Macintoshes equipped with Dove accelerator boards.
Early models of the Marathon 030 for Plus and SE computers have a defect that p
revents FileMaker and some other database software from running properly. Dove has incorporated a correction for this problem in current models of the board, and will update early versions at no charge. ContactC
Dove for an RMA number before returning your board for an update.
Contact:
Dove Computer Corporation
1200 North 23rd St.
Wilmington, NC 28405
(800) 622-7627
FileMaker
11/2/90M
BIMAR9030644518O
Copyright
Changing
Checkboxes
Choosing
Clipped
Cobra
Color
Colors
Compatibility
Considerations
Control
Converted
Converting
Crash
Current
Database
Defaults
Defining
Description
Design
Deskwriter
Deviation
Dialog
Disconnect
Drawn
Drives
Errors
Introduction
Investigate
Invisible
Involved
Involving
Layouts
Length
Letters
Letting
Level
Levels
Lifted
Light
Limit
Limitation
Limitations
Limited
Limits
Damaged
Damages
Database
Decide
Decides
Deepest
Default
Defaults
Defect
Define
Defined
Defines
Defining
Definitions
Degree
Delete
Deleted
Deleting
Describes
Description
Descriptions
Deselect
Deselected
Deselects
Design
Designed
Designing
Desired
Desktop
Deskwriter
Altogether
Always
Amount
And/or
Animation
Another
Appear
Appearance
Appeared
Appears
Disks
Disktop
Display
Displayed
Displaying
Disturbing
Document
Documentation
Documents
Doing
Dotted
Double-click
Paste
Pasted
Pastels
Pattern
Patterns
People
Perform
Performed
Performing
Permanently
Permit
Permitted
Personal
Picture
Pieces
Placed
Pop-up
Population
Popup
Possible
Pre-defined
Prevent
Prevents
Preview
Print
Printed
Printer
Printing
Printout
Prior
Nonsense
Nonsensical
Normally
North
Notice
Noticeable
Notifications@
OccursE
Operation@
Paging
Paste@
Quick@
Quite
Range@
Related@
Report
Seems
Several@
Simply@
Sort@
Sub-summary@
Summary
UnderO
Unused
Work]
AGConverting FileMaker II Files
Considerations, Caveats, First Aid Tips
FileMaker II files do not always convert properly into FileMaker Pro format.
Occasionally, a FileMaker II file will contain errors that prevent proper conversion. During the conversion process, you may get a l
ockup or crash, or a "Sorry, this file is damaged" message. Alternately, the file may convert properly, but certain features will not seem to work. For instance, scripts may not work properly, or fields may seeC
m missing from the Import/Export dialog box, layouts, or fields definitions.
These are just some of the symptoms of a long-standing programming defect in FileMaker II. This defect silently damages files, but o
ften does not cause noticeable problems in FileMaker II (which is one reason why it went unnoticed for so long). Claris discovered the problem while developing and testing FileMaker Pro, and corrected the problE
However, because the error affects the way data is organized inside a file, it is difficult to fully repair the damage caused by the FileMaker II problem. Your file may be more unstable in FileMaker Pro th
an FileMaker II. You could receive errors during the conversion process that make the file altogether unusable. If you do not have a backup copy of the file, your information could be lost forever.
Here's the G
best information we have on correcting problems uncovered by conversions:
If you have a copy of the FileMaker II version of the file
If you made a backup copy of your work, there is a good chance you can corre
ct the problem and try the conversion again.
1. Discard the converted version of the file and restore the original from backup disks.
2. Open FileMaker II.
3. Choose "Recover..." from the file menu, and open tI
he FileMaker II file.
4. When the recovery is complete, open the Recovered version of the file in FileMaker II
5. Choose the "Save a Copy..." command from the file menu. Save a compressed copy of the file.
hen the compression is complete, open FileMaker II and open FileMaker Pro.
7. Try to open the file. The file should convert properly.
If you do not have the FileMaker II version of the file
It is much more difK
ficult to recover your information if you do not have a copy of the FileMaker II file. However, the following techniques may work to salvage some information:
If the file crashed during conversion, try to op
en the file with FileMaker II. Try to recover the file with FileMaker II. (You may need to use a program like DiskTop to change the file type to FMK$.)
Try using FileMaker Pro to recover the file. Try recoverM
ing the recovered version.
If the file will open in FileMaker Pro, try deleting parts of the file which may be causing the problem.
Do you get a crash when paging to a certain record?
Create a new l
ayout with no fields. Make sure this is the current layout. Go to browse and switch to the problem record. Delete the record that you are having trouble viewing.
Do you crash when you execute a script?
Delete the script that is causing the problem, or delete all scripts.
Does a Clone (empty file) crash when you try to add data?
Try to Export the information in the file to a text file and rebuild t
he field definitions from scratch.
More about the Problem
Some people want a more technical/detailed description of the FileMaker II problem which causes these errors:
In FileMaker II and Pro, information hasQ
two "levels" of meaning. The first, basic layer is the data itself, a series of letters and numbers with no borders or structured arrangement. The second layer is a "map" or "tree" to the information. You can
think of a FileMaker file as a word search puzzle that has been solved. The letters on the grid represent your data, the ovals you draw around the words represents the structure of the file.
If the "map" of thS
e information is damaged, then it becomes difficult to sort out the data properly. Some circled letters actually work out to nonsense words. When FileMaker Pro encounters these nonsense words, problems start sh
owing in your files.
Recovering the FileMaker II file makes sure the map is in the best condition possible. Then, the compression operation makes a pass through the data, writing it to disk as tightly as possiU
ble with no regard to the "map," then re-builds the map from scratch to fit the shape of the data.
After these two operations, conversion of the file proceeds much more reliably in FileMaker Pro.
FileMaker
11/2/90M
BIMAR9030649106O
Copyright
A(Save a Copy As Pop-up Menu Not Available
Seems
Select
Selected
Selected/deselected
Selecting
Selection
Selections
Separate
Separation
Series
Session
Setting
Settings
Setup
Customers have reported problems accessing the "save a" pop-up menu in the Save a Copy As window when running FileMaker Pro on a IIci under MultiFinder. This problem seems to be limited to the IIci machines -B
a customer may have the same system configuration on another type of Macintosh, without experiencing this problem. Increasing the memory allocation for FileMaker Pro, or running the application under finder sC
eems to resolve the problem.
FileMaker
11/7/90
METHO9031135804O
Copyright
Crash On Rodime Cobra Drives
There is a confirmed conflict between FileMaker II and the drive firmware for Rodime's Cobra series of hard drives. Typically, the problem manifests itself by causing FileMaker to crash when selecting Page Setup or Print more than once in a given
session.
Button
Buttons
Bypassed
Range
Ranked
Rather
Re-builds
Reaches
Rearranges
Reason
Reasonable
Reboot
Rebuild
Recalculate
Recalculated
Recalculation
Receive
Received
Recent
Recently
Reconnecting
Record
Records
Recover
Recovered
Recovering
Recovery
Rectangle
Redefine
Redefining
Reestablished
References
Refreshes
Regard
Regardless
Region
Regions
Regular
Avoids
Backdrops
Background
Backup
Backward
Based
Basic
Batch
Because
The workaround is for the user to update his drive software. You can do this by running the Cobra Utilities program that ships with Cobra drives. There is an Update button, and when you click it, you will see a screen with three options: Help, OK and
Cancel. Select none of these. Instead, hold the shift key down and type an 'N'. Then click OK. Quit the Cobra Utilities and reboot, and the problem should be solved.
According to Rodime Technical Support, the problem occurs with versions 1.03 and 1.05 of their driver, and the above workaround will take care of it for these versions. A new version of the driver, 1.1, will solve the problem without needing to use the
above workaround.
The reason for the problem is that the earlier versions of the driver load some information into a particular location in RAM. FileMaker, PageMaker, and several other programs require a certain value in the same location. The shift-N workaround and the
XCobra 1.11 update change the way the driver loads into RAM, and so avoids the conflict.
jUsers of any Cobra drive can obtain the updated driver from Rodime free of charge by calling 407-997-0774.
FileMaker
11/2/90
BEDIE9030646920O
Copyright
"A-How to Renumber a Database with FileMaker Pro
Here's an easy way to renumber a FileMaker Pro database without using the lookup feature or requiring the import of any numbers:
1. Add Seed, a calculation field. Result Type of Number; Formula = Random
2. Aft
Summary
Superclock
Supply
Support
Supported
Suppose
Switch
Switching
Sydney
Symptoms
Synthesis
System
Taken
Taking
Technical
Technical/detailed
Technique
Techniques
Telling
Templates
Temporarily
Testing
er Seed is added (and calculated), change it to a Number field.
2. Add Index, a summary field that is the Count of Seed. Turn on the Running Count option.
3. Add Record #, a calculation field. Result Type of NuC
mber. Formula = Summary(Index, Seed)
4. Sort the database. The sort order should include
a. the criteria you want (last name, zip code, etc.)
b. lastly, the field Seed.
5. The record numbers appear inDA the field Record #. You can delete the other fields if you wish.
FileMaker
11/4/90M
CAMON9030854180O
Copyright
#A Standard Deviation of a "Sample"
Users
Using
Utilities
Utility
Valuable
Value
Values
Version
Versions
Viewed
Viewing
Viruses
Visual
Waiting
Wanted
Warning
Measurements
Memory
Memory-related
Mention
Menus
Merely
Message
Method
FileMaker Pro and FileMaker II provide a StDev function that allows you to calculate the standard deviation of a population represented by values in a repeating field. There is also a summary field option to caB
lculate this result over a range of records. You cannot use these built-in function, however, if you need to calculate the standard deviation of a sample. Certain professions require that the standard deviation
(.txt)